--*queryCountUser
--查询用户信息总条数
select count(*) from t_user t1,t_organization t2 where t1.comcode = t2.comcode(+)

--*queryAllUser
--查询所有用户信息
 select t1.*,t2.name as comName,to_char(t1.last_login_date,'yyyy-mm-dd hh24:mi:ss') as lastLoginTime from t_user t1,t_organization t2 where t1.comcode = t2.comcode(+)


--*queryUserSeqId
--自动增长列
SELECT SEQ_USER_ID.NEXTVAL as "SEQ_INDEX" FROM DUAL





